Excel 2013 - Autofill and Paste Options, Proofing Tools, Flash Fill and Macros

      The "Excel 2013 - Autofill and Paste Options, Proofing Tools, Flash Fill and Macros" lesson covers the following topics:
  • AutoFill and Paste Options
  • Proofing Tools
  • Flash Fill and Macros
     
      AutoFill and Paste Options      
      Upon successful completion you will be able to:

1. Use AutoFill;
2. Use Paste Options;
3. Perform Operations with Paste Special;
4. Copy Formatting with Paste Special.
     
      Proofing Tools      
      Upon successful completion you will be able to:

1. Modify Error Checking Settings;
2. Use the Error Checking Tool;
3. Spell Check Worksheets;
4. Use AutoComplete to Enter Data;
5. Use AutoCorrect;
6. Work with AutoCalculate.
     
      Flash Fill and Macros      
      Upon successful completion you will be able to:

1. Use Flash Fill;
2. Understand Macros;
3. Record Macros;
4. Assign Shortcut Keys to Macros;
5. Run Macros;
6. Add QAT buttons;
7. Display Shortcut Keys;
8. Change Button Icons;
9. Modify Macro Security Settings.
     
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2013 - Autofill and Paste Options, Proofing Tools, Flash Fill and Macros :
Program Training Courses - Microsoft Excel 2013 :
Office Suite Training Courses - Microsoft Office 2013 :
© 2017 Online Training Masters